Also see common JDBC Translator Information
The SAP Hana Translator, known by the name of hana, is for use with SAP Hana.
TEIID-3805 - The pushdown of the substring function is inconsistent with the Teiid substring function when the from index exceeds the length of the string. SAP Hana will return an empty string, while Teiid produces a null value.